Channel: Socratica

Category: Education

Tags: how to use views in sqlbeginner sql tutorialsql tutorial for beginnerslearn views in sqlsocraticacssqleasy sql tutorialdatabaseviewsql viewspostgresqlcreate viewcoalesce in sqlsql lessonsmysqlviewsdatabaseswhat are views in sqloraclesqlitecoalescelearn sqlcross joinunionconcatsql serversql for beginnersmariadbcross joins sqlsocraticaviews in sqlbeginner sqlstructured query languageconcat in sqlsql tutorial

Description: In SQL, a VIEW is a virtual table. It lets you package a complex query into a single table. We will discuss several queries in increasing difficulty to show how VIEWs can greatly simplify your work. In our examples we will introduce CROSS JOINs, Unions, the CONCAT() function, and the COALESCE() function. Our SQL playlist starts here: ↪bit.ly/Socratica_SQL Be sure to SUBSCRIBE for more SQL! ↪ bit.ly/SocraticaSubscribe You may also enjoy our Python playlist: ↪bit.ly/PythonSocratica ♦♦♦♦♦♦♦♦♦♦ Ways to support our channel: ►  Join our Patreon : patreon.com/socratica ►  Make a one-time PayPal donation: paypal.me/socratica ►  We also accept Bitcoin @ 1EttYyGwJmpy9bLY2UcmEqMJuBfaZ1HdG9 Thank you! ♦♦♦♦♦♦♦♦♦♦ Connect with us! Facebook: facebook.com/SocraticaStudios Instagram: instagram.com/SocraticaStudios Twitter: twitter.com/Socratica ♦♦♦♦♦♦♦♦♦♦ SQL instructor: Ulka Simone Mohanty (@ulkam on Twitter) Written & Produced by Kimberly Hatch Harrison (@khhsocratica) & Michael Harrison (@mlh496) ♦♦♦♦♦♦♦♦♦♦